Hi,
Is there any options available in DOORS to export the contents of Module explorer as well along with the module contents to an Excel sheet.
So the same root structure is available in the excel also.
Please let me know if there is any provision given in DOORS. Thanks.
BR,
Ashok
AshokNandha - Wed Jun 13 09:50:28 EDT 2012 |
|
Re: Exporting a module Contents to Excel along with Module explorer contents
SystemAdmin - Wed Jun 13 23:40:23 EDT 2012
There are no built-in options in DOORS that can export to MS Excel and use Excels "Outline" feature to replicate the object structure of the DOORS module. I assume that is what you want to do. This would be a nice feature to have.
Rather than trying to do this in DXL, it might be easier to write a VBA macro in Excel that can be applied after the export - if you included the "Object Number" and "Object Level" attributes in the export, the VBA macro could use these to determine the groupings needed to build the outline in Excel.
Paul Miller
Melbourne, Australia
|
|
Re: Exporting a module Contents to Excel along with Module explorer contents
AshokNandha - Thu Jun 14 04:00:30 EDT 2012 SystemAdmin - Wed Jun 13 23:40:23 EDT 2012
There are no built-in options in DOORS that can export to MS Excel and use Excels "Outline" feature to replicate the object structure of the DOORS module. I assume that is what you want to do. This would be a nice feature to have.
Rather than trying to do this in DXL, it might be easier to write a VBA macro in Excel that can be applied after the export - if you included the "Object Number" and "Object Level" attributes in the export, the VBA macro could use these to determine the groupings needed to build the outline in Excel.
Paul Miller
Melbourne, Australia
Yes, you are right. Its better to go with Macro in Excel.
I will create a macro for this. Thanks a lot for the response!!
Ashok Nandha
Hildesheim, Germany
|
|